Mega Code Archive
Math Functions
1) ABS function returns the absolute value of any number passed to it
2) ACOS Returns as a float data type, the angle in radians that corresponds to the entered cosine, which must have values betw
3) ASIN Returns as a float data type, the angle in radians that corresponds to the entered sine, which must have values betwee
4) ATAN Returns as a float data type, the angle in radians that corresponds to the entered tangent
5) CASE with FLOOR function
6) CEILING function returns the value representing the smallest integer that is greater-than or equal to the input_number
7) Computing the modulus with FLOOR
8) COS Returns a float value that is the cosine of the angle passed in as a parameter
9) COT returns a float value that is the cotangent of the angle passed in as a parameter
10) DEGREES converts a float value, which represents an angle in radians, into the value of this angle in degrees
11) EXP Returns a float, which is the exponential of the float value passed in as a parameter
12) FLOOR returns the value that represents the largest integer that is less-than or equal to the input_number
13) LOG Takes one positive valued parameter, and returns the natural logarithm of this parameter as a float value
14) LOG10 returns the base 10 logarithm of this parameter as a float value
15) MAX(CEILING(price))
16) MIN(FLOOR(price))
17) PI Returns the value of the mathematical constant PI to 16 decimal places
18) POWER returns a number (input_x) raised to the power of a number (input_y)
19) RADIANS Converts a value in degrees to a value in radians
20) RAND Generates a random number between 0 and 1, which is returned as a float
21) RAND Returns random number from 0 to 1
22) Returning the decimal portion using FLOOR
23) ROUND(salary 1 1, 2)
24) Rounding present value to two decimal places
25) Rounds a value to the number of decimal places specified in the second parameter
26) Select ABS(-1 25)
27) Select CEILING (1 25)
28) Select CEILING(-1 25) (Minus)
29) Select FLOOR(1 25)
30) Select FLOOR(-1 25) (minus)
31) Select ISNUMERIC(-1 25)
32) SELECT ISNUMERIC(123)
33) SELECT ISNUMERIC(123ABC)
34) Select ISNUMERIC(2001-09-30)
35) Select ISNUMERIC(SQL Server)
36) SELECT POWER(10,2) Result
37) Select RAND()
38) SELECT RAND(22) Result
39) Select ROUND(12 4999,0)
40) Select ROUND(12 4999,1)
41) Select ROUND(12 4999,-1) (Minus)
42) Select ROUND(12 5,0)
43) Select ROUND(12 5,0,1)
44) SELECT ROUND(3 22245, 3) RoundedNumber
45) SELECT SQRT(100) Result
46) Select SQRT(125 43)
47) Select SQUARE(5 2786)
48) SIGN returns a -1 if the number is negative, +1 if the number is positive, or 0 if the number is 0
49) SIN returns a float value that is the sine of the angle passed in as a parameter
50) Sin, COS and Tan
51) SQRT function returns the square root of a value 0 or greater
52) SQUARE Returns the square of the given number
53) TAN return a float value that is the tangent of the angle passed in as a parameter